EMT Practice Test

1. Question Content...

---

Question1: What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.

Question2: Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

Question3: You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)

Question4: What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question

Question5: Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question

Question6: Which of the following is true?

Question7: What is an attribute view and what are its practices? There are 3 correct answers to this question.

Question8: You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? There are 3 correct answers to this question.

Question9: What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

Question10: What is Core Data Services (CDS)?

Question11: DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

Question12: You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.

Question13: How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?
Please choose the correct answer.

Question14: You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.
Which additional steps are necessary to retrieve the result set into an internal table? 2 ans

Question15: You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain?
There are 2 correct answers to this question.

Question16: HANA modeling views can be created under

Question17: What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

Question18: What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer

Question19: In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

Question20: What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question.

Question21: You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

Question22: Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.

Question23: SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.

Question24: You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

Question25: What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.

Question26: Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.

Question27: Where can you consume associations in a Core Data Services (CDS) view? 3 ans

Question28: What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.

Question29: What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.

Question30: Which of the statements are true for SQLScript? (2 answers)

Question31: What made SAP HANA possible?

Question32: You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

Question33: You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecesary load away from the database"? Choose the correct answer

Question34: Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.

Question35: Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are
2 correct answers to this question.

Question36: ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA. What are these transparent optimizations? (3 ans)

Question37: What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question.

Question38: What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.

Question39: How can you consume a Core Data Services (CDS) view? 2 ans

Question40: Which TADIR object type is used for the definition of a Core Data Services (CDS) view?

Question41: Which SAP HANA engine executes Calculation view? (2 answers)

Question42: Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question.

Question43: What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

Question44: What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

Question45: Which engine is used to execute Analytic View?

Question46: Which repository objects can you edit only in the ABAP development tools in eclipse and not in the classical abap workbench? There are 3 correct answers to this question.

Question47: What is the full form of HANA?

Question48: What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.

Question49: Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

Question50: What should you do to follow the code-to-data approach to programming? 2 ans

Question51: Which is better from performance point of view?

Question52: What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

Question53: You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?

Question54: You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

Question55: The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies?
There are 3 correct answers to this question

Question56: Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.

Question57: You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?

Question58: You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans

Question59: What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)

Question60: What output does the SAP HANA provide as a unique combination of hardware and software innovations?
Please choose the correct answer.

Question61: You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer.

Question62: Which of the following JOIN types are supported in Open SQL? 3 ans

Question63: What is the main purpose of Analytic Privilege?

Question64: The SAP HANA state-of-the-art search experience includes full-text search with advanced features like...
There are 3 correct answers to this question.

Question65: Analytic Privilege can be applied to (3 Answers)

Question66: What is the operating system supported by HANA? (2 correct answers)

Question67: The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question.

Question68: Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? There are 3 correct answers to this question.

Question69: Which recent software innovations are applied in SAP HANA? 3 ans

Question70: What are the supported joins in CDS view? There are 2 correct answers to this question.

Question71: You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

Question72: You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
There are 3 correct answers to this question.

Question73: Which of the following is latest release of SAP HANA?

Question74: Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture?
Choose the correct answer

Question75: Which statement is true for SAP HANA?

Question76: What all are the factors involved in Working with ADT.
If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available?
There are 3 correct answers to this question.

Question77: What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are
3 correct answers to this question.

Question78: What language one should know to work in SAP HAN A?

Question79: Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question.

Question80: ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

Question81: What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

Question82: Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans

Question83: Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

Question84: You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.